package com.bkgy.modular.qms.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.apache.ibatis.type.BlobTypeHandler;
import org.apache.ibatis.type.JdbcType;

import java.util.Date;

/**
 * qms对接oracle数据库,查Blob数据
 */
@AllArgsConstructor
@NoArgsConstructor
@Data
@TableName(value = "QMS.TB_CURVE_DATA",autoResultMap = true)
public class QmsCurveData {
    @TableField(value = "ID",jdbcType = JdbcType.VARCHAR)
    private String id;
    @TableField(value = "MAT_NO",jdbcType = JdbcType.VARCHAR)
    private String mat_no;
    @TableField(value = "NAME",jdbcType = JdbcType.VARCHAR)
    private String name;
    @TableField(value = "DATA",jdbcType = JdbcType.BLOB,typeHandler = BlobTypeHandler.class)
    private byte[] data;
    @TableField(value = "TIME",jdbcType = JdbcType.DATE)
    private Date time;
    @TableField(value = "DEVICE_NO",jdbcType = JdbcType.VARCHAR)
    private String device_no;
    @TableField(value = "RESOLUTION",jdbcType = JdbcType.NUMERIC)
    private Double resolution;
    @TableField(value = "RESOLUTION_UNIT",jdbcType = JdbcType.VARCHAR)
    private String resolution_unit;
}
